﻿use [{0}]
if not exists (
	select * 
	from Gene 
	where AccessionVersion = @AccessionVersion 
	and GeneId = @GeneId
	and GenbankId = @GenbankId
)
begin
INSERT INTO Gene
           (AccessionVersion
           ,GeneId
           ,GenbankId
           ,LocusTag
           ,Symbol
           ,Cog
           ,Translation
           ,Product
           ,ProteinId
           ,Note)
     VALUES
           (@AccessionVersion,
            @GeneId,
            @GenbankId,
            @LocusTag,
            @Symbol,
            @Cog,
            @Translation,
            @Product,
            @ProteinId,
            @Note)
select 1
end
else begin
select 0
end